package com.aixin.csopuser.repository;


import com.aixin.csopuser.domain.CustomerOwnedServices;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.List;
import java.util.Optional;

public interface CustomerOwnedRepository extends JpaRepository<CustomerOwnedServices,Long> {

//    Optional<CustomerOwnedServices> findByCustomerIDAndPolicyID(String customerID, String policyID);
    List<CustomerOwnedServices> findAllByCustomerIDAndEquityIDAndEquityLevelIDOrderByCustServiceNumAscCreateTimeDesc(String customerID, String equityID, String equityLevelID);

    List<CustomerOwnedServices> findAllByCustServiceNumOrderByCreateTimeDesc(String serviceID);
}
